package com.ruiyian.bridge.info.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruiyian.bridge.info.domain.DipmonitorInfo;
import com.ruiyian.bridge.project.domain.vo.DataAnalysisDto;
import com.ruiyian.bridge.project.domain.vo.DataAnalysisVo;
import com.ruiyian.bridge.project.domain.vo.Mmh2oQueryBo;
import com.ruiyian.bridge.project.domain.vo.MonitorDataExcelBo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Description: 倾角监测数据
 * @Author: chonge
 * @Date: 2020-08-25
 * @Version: V1.0
 */
public interface DipmonitorInfoMapper extends BaseMapper<DipmonitorInfo> {
    DataAnalysisVo getNowMinData(@Param("addr") String addr, @Param("macaddr") String macaddr, @Param("startTime") String startTime, @Param("endTime") String endTime);

    List<DataAnalysisVo> getDataList(@Param("startNum") Long startNum, @Param("endNum") Long endNum);


    Long queryCount();

    Long queryRemoteCount();

    List<DataAnalysisVo> getNowMinDataByType(DataAnalysisDto dataAnalysisDto);

    DataAnalysisVo queryNowDisByDateType(DataAnalysisDto dataAnalysisDto);

    /**
     * 查询倾角数据 时间范围
     * @param bo
     * @return
     */
    List<DataAnalysisVo> queryDataListForSummary(Mmh2oQueryBo bo);

    /**
     * 多维度类型统计
     * @param dto
     * @return
     */
    List<DataAnalysisVo> queryByDateType(DataAnalysisDto dto);

    List<DataAnalysisVo> queryByDateSenNoCorr(DataAnalysisDto dto);

    List<DataAnalysisVo> queryDisByDateSenNo(DataAnalysisDto dto);

    /**
     * 数据导出查询
     * @param query
     * @return
     */
    List<DataAnalysisVo> queryMonitorDataPageList(MonitorDataExcelBo query);
}
